Lab 4 - Database Connection

a. Problem Statement

Task 1:
Consider the project database designed and implemented during previous semester i.e. Fall 2024. Its implementation was done using structured query language during previous semester. Try to recall major relations in your project database. You already have its report in printed form.

• Create a website project using a blank folder as demonstrated in class.
• Add a web form with separate code to the project.
• Test the web form by running it in browser.
• Write code to retrieve data from any of your project table. Display a few fields in browser.

Task 2:
Connect and query a SQL Server instance using Visual Studio.
Follow the instructions https://learn.microsoft.com/en-us/ssms/quickstarts/ssms-connect-query-sql-server

b. Code Report

c. Sample Outputs

(Task 1)

(Task 2)

d. Demonstration Pages